{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["C-GEFH W&B"],"not_rendered":{"charts":1,"macros":1,"defined_names":1},"read":"whole","date_system":"1904"}

{"sheet":"C-GEFH W&B","index":0,"n_rows":44,"n_cols":13,"rows_kept":44,"merged":[[0,1,0,5],[1,1,1,2],[1,3,1,4],[1,7,1,8],[2,7,2,8],[3,7,3,8],[3,9,3,10],[3,11,3,12],[10,1,10,5],[10,7,10,8],[11,7,11,8],[25,7,25,9],[26,7,26,9],[27,7,27,9],[28,7,28,9]]}
[null,"*** Calculator provided as an aid only. PIC is responsible for calculating weight and balance for flight planning ***"]
[null,"Weight and Balance Worksheet",null,"1975 Cessna 172M",null,"C-GEFH",null,"USAGE:"]
[null,"Item",null,"Weight","Arm","Moment",null,"Fill areas in GREEN"]
[null,"Aircraft Licensed Empty Weight (incl unusable fuel)",null,{"v":1474.51,"d":"1474.51 lb"},{"$f":"F4/D4","v":{"v":41.87810187791199,"d":"41.88 in"}},{"v":61749.68,"d":"61749.68 lb-in"},null,"Seat Occupancy Table:",null,"Other Information",null,"P.O.H. Limitations"]
[null,"Oil (8 Quarts Maximum)",{"$f":"K5","v":{"v":7,"d":"7.0 qt"}},{"$f":"1.875*C5","v":{"v":13.125,"d":"13.13 lb"}},{"v":-14,"d":"-14.00 in"},{"$f":"D5*E5","v":{"v":-183.75,"d":"-183.75 lb-in"}},null,"Pilot:",{"v":200,"d":"200 lb"},"Oil (qts):",{"v":7,"d":"7.0 qt"},"Max Gross Weight =",{"v":2300,"d":"2300 lb"}]
[null,"Fuel (48 Gallons Maximum Usable)",{"$f":"K6","v":{"v":24,"d":"24.0 gal"}},{"$f":"6*C6","v":{"v":144,"d":"144.00 lb"}},{"v":48,"d":"48.00 in"},{"v":6912,"d":"6912.00 lb-in"},null,"Copilot:",{"v":0,"d":"0 lb"},"Fuel (gal):",{"v":24,"d":"24.0 gal"},"Max Baggage Area 1 =",{"v":120,"d":"120 lb"}]
[null,"Front Seats",null,{"$f":"SUM(I5,I6)","v":{"v":200,"d":"200 lb"}},{"v":37,"d":"37.00 in"},{"v":7400,"d":"7400.00 lb-in"},null,"Rear Left:",{"v":0,"d":"0 lb"},"Baggage 1:",{"v":0,"d":"0 lb"},"Max Baggage Area 2 =",{"v":50,"d":"50 lb"}]
[null,"Rear Seats",null,{"$f":"SUM(I7,I8)","v":{"v":0,"d":"0 lb"}},{"v":73,"d":"73.00 in"},{"v":0,"d":"0.00 lb-in"},null,"Rear Right:",{"v":0,"d":"0 lb"},"Baggage 2:",{"v":5,"d":"5 lb"},"Aft CG limit =",{"v":47.5,"d":"47.5 in"}]
[null,"Baggage Area  1",null,{"$f":"+K7","v":{"v":0,"d":"0 lb"}},{"v":95,"d":"95.00 in"},{"v":0,"d":"0.00 lb-in"},{"$nulls":3},"NOTE: Fuel in USG",null,"Fore CG Limit T/O =",{"v":35,"d":"35.0 in"}]
[null,"Baggage Area  2",null,{"$f":"+K8","v":{"v":5,"d":"5 lb"}},{"v":123,"d":"123.00 in"},{"v":615,"d":"615.00 lb-in"},{"$nulls":5},"Fore CG LDG =",{"v":35,"d":"35.0 in"}]
[null,"C A L C U L A T E D    V A L U E S",{"$nulls":5},"Remaining Useful Load:",{"$nulls":3},"Max Usable Fuel =",{"v":48,"d":"48.0 gal"}]
[null,"TAKE OFF PARAMETERS",null,{"$f":"SUM(D4:D11)","v":{"v":1836.635,"d":"1836.6 lb"}},{"$f":"F12/D12","v":{"v":41.64841136099442,"d":"41.6 in"}},{"$f":"SUM(F4:F11)","v":{"v":76492.93,"d":"76493 lb-in"}},{"$f":"F12/1000","v":{"v":76.49292999999999,"d":"76.49"}},{"$f":"M5-D12","v":{"v":463.365,"d":"463 LBS"}},{"$nulls":3},"Fuel Min (for safety)=",{"v":8,"d":"8.0 gal"}]
[null,"Less Fuel Used",{"v":5,"d":"5.0 gal"},{"$f":"6*C13*-1","v":{"v":-30,"d":"-30.0 lb"}},{"$f":"+E6","v":{"v":48,"d":"48.0 in"}},{"$f":"D13*E13","v":{"v":-1440,"d":"-1440 lb-in"}}]
[null,"LANDING PARAMETERS",null,{"$f":"+D12+D13","v":{"v":1806.635,"d":"1806.6 lb"}},{"$f":"+F14/D14","v":{"v":41.54294032828988,"d":"41.5 in"}},{"$f":"+F13+F12","v":{"v":75052.93,"d":"75053 lb-in"}},{"$f":"+F14/1000","v":{"v":75.05292999999999,"d":"75.05"}}]
[]
[]
[]
[{"$nulls":7},"Warnings:"]
[{"$nulls":7},{"$f":"IF(D12>M5,\"Warning: Maximum Gross Weight Exceeded\",\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(((D9)>(M6)),\"Warning: Too Much Baggage Area 1\",\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(((D10)>(M7)),\"Warning: Too Much Baggage Area 2\",\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(MAX(E12)>M8,\"Warning: C.G. Too Far Aft\",\"\")&IF((E12<M9),\"Warning: C.G. Too Far Forward\",\"\")","v":""}]
[null,"Utility",null,null,"Normal",null,null,{"$f":"IF((C6)>M11,\"Error: Too Much Fuel\",\"\")&IF(C6<M12,\"Warning: Low Fuel\",\"\")&IF(K6-C13<M12,\"Warning: Low Fuel\",\"\")","v":""}]
[null,35,1500,null,35,1500,null,{"$f":"IF(D14>C25,IF(MAX(E14)>M8,\"Warning: C.G. Too Far Aft for Landing\",\"\")&IF((E14<M10),\"Warning: C.G. Too Far Forward for Landing\",\"\"),IF(MAX(E14)>M8,\"Warning: C.G. Too Far Aft for Landing\",\"\")&IF((E14<B24*1000/C24),\"Warning: C.G. Too Far Forward for Landing\",\"\"))","v":""}]
[null,35,1950,null,35,1950]
[null,35.5,2000,null,38.5,2300,null,"SETUP:"]
[null,40.5,2000,null,38.5,2300,null,"Set the following parameters for your"]
[null,40.5,1500,null,47.3,2300,null,"specific aircraft:"]
[{"$nulls":4},47.3,1500,null,"Cell D4:  Aircraft Empty Weight"]
[null,"Takeoff",{"$nulls":5},"Cell F4:  Aircraft Moment"]
[null,"For variable fore CG above 1950 lb",{"$f":"C33/C32","v":{"$error":"#DIV/0!"}},null,"CG Range",null,null,"Cell E5:  Oil Arm"]
[null,"CG Weight",{"$f":"SLOPE(F26:F27,E26:E27)*(C33/1000)+INTERCEPT(F26:F27,E26:E27)","v":{"$error":"#DIV/0!"}},null,"Utility","Normal",null,"Cell E6:  Fuel Arm"]
[null,"CG Moment",{"$f":"(D12-INTERCEPT(F26:F27,E26:E27))/SLOPE(F26:F27,E26:E27)*1000","v":{"$error":"#DIV/0!"}},null,{"$f":"B24*1000/C24","v":{"v":23.333333333333332,"d":"23.3"}},{"$f":"E24*1000/F24","v":{"v":23.333333333333332,"d":"23.3"}},null,"Cell E7:  Front Seats Arm"]
[{"$nulls":4},{"$f":"B25*1000/C25","v":{"v":17.94871794871795,"d":"17.9"}},{"$f":"E25*1000/F25","v":{"v":17.94871794871795,"d":"17.9"}},null,"Cell E8:  Rear Seats Arm"]
[null,"Landing",null,null,{"v":17.75,"d":"17.8"},{"v":16.73913043478261,"d":"16.7"},null,"Cells E9 / E10:  Baggage Area Arms"]
[null,"For variable fore CG above 1950 lb",{"$f":"C38/C37","v":{"$error":"#DIV/0!"}},null,{"v":20.25,"d":"20.3"},{"v":16.73913043478261,"d":"16.7"}]
[null,"CG Weight",{"$f":"SLOPE(F26:F27,E26:E27)*(C38/1000)+INTERCEPT(F26:F27,E26:E27)","v":{"$error":"#DIV/0!"}},null,{"v":27,"d":"27.0"},{"v":20.565217391304348,"d":"20.6"},null,"If you need to change the envelopes on "]
[null,"CG Moment",{"$f":"(D14-INTERCEPT(F26:F27,E26:E27))/SLOPE(F26:F27,E26:E27)*1000","v":{"$error":"#DIV/0!"}},null,null,{"v":31.533333333333335,"d":"31.5"},null,"the operating chart:   Drag the chart"]
[{"$nulls":7},"to the right or down to reveal the cells "]
[{"$nulls":7},"behind it and modify them to match the"]
[{"$nulls":7},"chart for your aircraft."]
[]
[{"$nulls":7},"Note: Calculation sheet current as of"]
[{"$nulls":7},"weight & balance dated 18-APR-2019."]